package com.sh.dc.mapper;

import com.sh.dc.common.pojo.dto.TaskStatusCountDto;
import com.sh.dc.entity.TaskSolver;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 求解任务表 Mapper 接口
 * </p>
 *
 * @author zhenlan
 * @since 2024-09-19
 */
public interface TaskSolverMapper extends BaseMapper<TaskSolver> {

    @Select("SELECT status, COUNT(*) AS count FROM t_task_solver where deleted = 0 GROUP BY status")
    List<TaskStatusCountDto> countStatus();


}
